How to: Add a title to a chart.
Solution:
Select the chart, select the 'Insert' menu and select 'Titles...'. Select 'Chart Title' check box and type the title text.
To add a chart title:
1) Double-click on the chart for which to add a title. (A striped border with handles appears around the chart.)
2) Select the 'Insert' menu and select 'Titles...'. (The Titles dialog box appears.)
3) Select the 'Chart Title' check box in the 'Attach Text to' group.
Chart Title
4) Click 'OK'. (A text box with the word Title appears on the chart.)
5) Type the desired title for the chart.
6) Press ENTER. (The desired title replaces the word Title.)
7) (Optional) Resize the box to fit the title or move the box to the desired location.